Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# AGGMAP SET

Specifies the default aggmap for a variable.

Note: You can also use an $AGGMAP property to specify the default aggregation specification for a variable or the $ALLOCMAP property to specify the default allocation specification for a variable.

Syntax

AGGMAP SET aggmap AS DEFAULT FOR variables

Arguments

aggmap

  The name of a previously defined aggmap object.

variables

  A text expression that is the name of one or more variables for which the specified aggmap is the default aggmap. When you specify a literal value, separate the names of the variables with commas.

Examples

Example 6-41 Using AGGMAP SET to Specify a Default Aggmap

Example 6-2, "Using the $AGGREGATE_FROM Property" illustrates how the AGGREGATE command shown in Example 6-28, "Using a CACHE Statement in an Aggregation Specification" can be simplified to the following statement.

    AGGREGATE sales_by_revenue USING revenue_aggmap

You can further simplify the AGGREGATE command if you make `revenue_aggmap` the default aggmap for the `sales_by_revenue` variable. You can do this either by defining an $AGGMAP property on the `sales_by_revenue` variable or by issuing the following statement.

    AGGMAP SET revuienue_aggmap AS DEFAULT FOR sales_by_revenue

Now you can aggregate the data by issuing the following AGGREGATE command that does not include a USING clause.

    AGGREGATE sales_by_revenue